<?php
/**
	获取记录并分页展示JSON（追梦者模板）
**/

$cfg_NotPrintHead = false;
header("Content-Type: text/html; charset=UTF-8");
include_once (dirname(__FILE__)."/../include/common.inc.php");


function lib_replace_end_tag($str)
{
if (empty($str)) return false;
$str = htmlspecialchars($str);
$str = str_replace( '/', "", $str);
$str = str_replace("\\", "", $str);
$str = str_replace("&gt", "", $str);
$str = str_replace("&lt", "", $str);
$str = str_replace("<SCRIPT>", "", $str);
$str = str_replace("</SCRIPT>", "", $str);
$str = str_replace("<script>", "", $str);
$str = str_replace("</script>", "", $str);
$str=str_replace("select","select",$str);
$str=str_replace("join","join",$str);
$str=str_replace("union","union",$str);
$str=str_replace("where","where",$str);
$str=str_replace("insert","insert",$str);
$str=str_replace("delete","delete",$str);
$str=str_replace("update","update",$str);
$str=str_replace("like","like",$str);
$str=str_replace("drop","drop",$str);
$str=str_replace("create","create",$str);
$str=str_replace("modify","modify",$str);
$str=str_replace("rename","rename",$str);
$str=str_replace("alter","alter",$str);
$str=str_replace("cas","cast",$str);
$str=str_replace("&","&",$str);
$str=str_replace(">",">",$str);
$str=str_replace("<","<",$str);
$str=str_replace(" ",chr(32),$str);
$str=str_replace(" ",chr(9),$str);
$str=str_replace("    ",chr(9),$str);
$str=str_replace("&",chr(34),$str);
$str=str_replace("'",chr(39),$str);
$str=str_replace("<br />",chr(13),$str);
$str=str_replace("''","'",$str);
$str=str_replace("css","'",$str);
$str=str_replace("CSS","'",$str);
 
return $str;
 
}



error_reporting(E_ALL || ~E_NOTICE);
include_once (dirname(__FILE__)."/../include/json.class.php");

	$page = intval($pageNum);
	$aid = intval($aid);
	$tj = $dsql->GetOne("SELECT COUNT(aid) FROM `#@__pinglun` where aid='$aid'");
	$total = $tj['COUNT(aid)'];//总记录数
	
	$pageSize = 70; //每页显示数
	$totalPage = ceil($total/$pageSize); //总页数
	
	$startPage = $page*$pageSize;
	$arr['total'] = $total;
	$arr['pageSize'] = $pageSize;
	$arr['totalPage'] = $totalPage;
	
	
	$dsql->SetQuery("select pl.*,mb.face,uname from `#@__pinglun` as pl
	left join `#@__member` mb on mb.mid=pl.mid where aid='$aid' order by addtime desc limit $startPage,$pageSize");
	$dsql->Execute('me');
	while ($row = $dsql->GetArray('me')) {
		if($row['face']==''){
		$row['face']='/member/templets/images/dfboy.png';
		}
			$arr['list'][] = array(
			'uname' => $row['uname'],
			'id' => $row['id'],
			'addtime' => date('Y-m-d H:i',$row['addtime']),
			'face' => $row['face'],
			'msg' => $row['msg'],
		 );
	}
	$json = new Services_JSON(SERVICES_JSON_SUPPRESS_ERRORS);
	echo json_encode($arr);	
?>